package com.sc.nft.mapper;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.sc.nft.entity.ReportAmount;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sc.nft.entity.ReportBalance;
import com.sc.nft.entity.vo.ReportAmountVO;
import com.sc.nft.entity.vo.TotalReportAmountVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

/**
 * (sc_report_amount)数据Mapper
 *
 * @author Sun
 * @since 2023-02-20 14:10:29
 * @description 由 Mybatisplus Code Generator 创建
*/
@Mapper
public interface ReportAmountMapper extends BaseMapper<ReportAmount> {

    List<ReportBalance> getByTime(@Param("time") String time);

    /**
     * 分页查询财务数据
     * @param beginTime
     * @param endTime
     * @return
     */
    Page<ReportAmountVO> getPageReportAmount(Page page, @Param("beginTime") String beginTime, @Param("endTime") String endTime);

    /**
     * 合计分页数据
     * @param beginTime
     * @param endTime
     * @return
     */
    TotalReportAmountVO getTotalReportAmount(@Param("beginTime") String beginTime,@Param("endTime") String endTime);
}
